
<html><HEAD>
<LINK REL=STYLESHEET HREF="default.css" TYPE="text/css">
<TITLE>
Migrating from the MSS or OLE DB database interfaces</TITLE>
</HEAD>
<BODY>

<!-- Header -->
<p class="ancestor" align="right"><A HREF="connpbp58.htm">Previous</A>&nbsp;&nbsp;<A HREF="connpbp60.htm" >Next</A>
<!-- End Header -->
<A NAME="BABJCJEH"></A><h1>Migrating from the MSS or OLE DB database interfaces</h1>
<A NAME="TI1093"></A><p>In earlier releases of PowerBuilder, the MSS native interface
was provided for connection to Microsoft SQL Server. This native
interface was based on Microsoft DB-LIB functionality, which is
no longer supported by Microsoft and is not Unicode-enabled. The
MSS interface was removed in PowerBuilder 10.0. </p>
<A NAME="TI1094"></A><p>Prior to the introduction of SQL Server 2005 and SQL Native
Client, Microsoft recommended using the OLE DB database interface
and MDAC to connect to SQL Server. You can continue to use this
solution if you do not need to take advantage of new features in
SQL Server 2005 or SQL Server 2008.</p>
<A NAME="TI1095"></A><p>This section provides a comparison between database parameters
you might have used in existing applications with the parameters
you can use with the SNC database interface.</p>
<A NAME="CEGCCDDB"></A><h4>MSS database parameters
supported by SNC</h4>
<A NAME="TI1096"></A><p><A HREF="connpbp59.htm#BABEJDBC">Table 9-2</A> shows
the database parameters and preferences that could be set in the
Database Profile Setup dialog box for the discontinued MSS native database
interface for Microsoft SQL Server, and indicates whether they are supported
by the SNC interface. </p>
<A NAME="TI1097"></A><p>The column on the left shows the tab page in the Database
Profile Setup dialog box for MSS. The parameters and preferences
may be on different tab pages in the SNC profile.</p>
<A NAME="BABEJDBC"></A><table cellspacing=0 cellpadding=6 border=1 frame="void" rules="all"><caption>Table 9-2: MSS parameters supported by SNC</caption>
<tr><th  rowspan="1"  ><A NAME="TI1098"></A>MSS</th>
<th  rowspan="1"  ><A NAME="TI1099"></A>SNC</th>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1100"></A><strong>Connection tab:</strong></td>
<td  rowspan="1"  ><A NAME="TI1101"></A></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1102"></A>Language</td>
<td  rowspan="1"  ><A NAME="TI1103"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1104"></A>Lock</td>
<td  rowspan="1"  ><A NAME="TI1105"></A>Supported (Transaction tab)</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1106"></A>AutoCommit</td>
<td  rowspan="1"  ><A NAME="TI1107"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1108"></A>CommitOnDisconnect</td>
<td  rowspan="1"  ><A NAME="TI1109"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1110"></A><strong>System tab:</strong></td>
<td  rowspan="1"  ><A NAME="TI1111"></A></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1112"></A>Log</td>
<td  rowspan="1"  ><A NAME="TI1113"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1114"></A>SystemProcs</td>
<td  rowspan="1"  ><A NAME="TI1115"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1116"></A>PBCatalogOwner</td>
<td  rowspan="1"  ><A NAME="TI1117"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1118"></A><strong>Transaction tab:</strong></td>
<td  rowspan="1"  ><A NAME="TI1119"></A></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1120"></A>Async</td>
<td  rowspan="1"  ><A NAME="TI1121"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1122"></A>DBGetTime</td>
<td  rowspan="1"  ><A NAME="TI1123"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1124"></A>CursorLock</td>
<td  rowspan="1"  ><A NAME="TI1125"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1126"></A>CursorScroll</td>
<td  rowspan="1"  ><A NAME="TI1127"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1128"></A>StaticBind</td>
<td  rowspan="1"  ><A NAME="TI1129"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1130"></A>MaxConnect</td>
<td  rowspan="1"  ><A NAME="TI1131"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1132"></A><strong>Syntax tab:</strong></td>
<td  rowspan="1"  ><A NAME="TI1133"></A></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1134"></A>DBTextLimit</td>
<td  rowspan="1"  ><A NAME="TI1135"></A>Supported (as PBMaxTextSize on Transaction
tab)</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1136"></A>DateTimeAllowed</td>
<td  rowspan="1"  ><A NAME="TI1137"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1138"></A>OptSelectBlob</td>
<td  rowspan="1"  ><A NAME="TI1139"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1140"></A><strong>Network tab:</strong></td>
<td  rowspan="1"  ><A NAME="TI1141"></A></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1142"></A>AppName</td>
<td  rowspan="1"  ><A NAME="TI1143"></A>Supported (System tab)</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1144"></A>Host</td>
<td  rowspan="1"  ><A NAME="TI1145"></A>Supported (System tab)</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1146"></A>PacketSize</td>
<td  rowspan="1"  ><A NAME="TI1147"></A>Supported (System tab)</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1148"></A>Secure</td>
<td  rowspan="1"  ><A NAME="TI1149"></A>Supported (as TrustedConnection on General
tab)</td>
</tr>
</table>
<A NAME="TI1150"></A><h4>OLE DB database parameters supported by SNC</h4>
<A NAME="TI1151"></A><p><A HREF="connpbp59.htm#BABHAJEE">Table 9-3</A> shows
the database parameters and preferences that can be set in the Database
Profile Setup dialog box for the OLE DB standard interface for Microsoft
SQL Server, and indicates whether they are supported by the SNC interface. </p>
<A NAME="TI1152"></A><p>The column on the left shows the tab page in the Database
Profile Setup dialog box for OLE DB. The parameters and preferences
may be on different tab pages in the SNC profile.</p>
<A NAME="BABHAJEE"></A><table cellspacing=0 cellpadding=6 border=1 frame="void" rules="all"><caption>Table 9-3: OLE DB parameters supported by SNC</caption>
<tr><th  rowspan="1"  ><A NAME="TI1153"></A>OLE DB</th>
<th  rowspan="1"  ><A NAME="TI1154"></A>SNC</th>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1155"></A><strong>Connection tab:</strong></td>
<td  rowspan="1"  ><A NAME="TI1156"></A></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1157"></A>Provider</td>
<td  rowspan="1"  ><A NAME="TI1158"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1159"></A>DataSource</td>
<td  rowspan="1"  ><A NAME="TI1160"></A>Supported at runtime (as SQLCA.ServerName)</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1161"></A>DataLink</td>
<td  rowspan="1"  ><A NAME="TI1162"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1163"></A>Location</td>
<td  rowspan="1"  ><A NAME="TI1164"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1165"></A>ProviderString</td>
<td  rowspan="1"  ><A NAME="TI1166"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1167"></A><strong>System tab:</strong></td>
<td  rowspan="1"  ><A NAME="TI1168"></A></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1169"></A>PBCatalogOwner</td>
<td  rowspan="1"  ><A NAME="TI1170"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1171"></A>ServiceComponents</td>
<td  rowspan="1"  ><A NAME="TI1172"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1173"></A>AutoCommit</td>
<td  rowspan="1"  ><A NAME="TI1174"></A>Supported (General tab)</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1175"></A>CommitOnDisconnect</td>
<td  rowspan="1"  ><A NAME="TI1176"></A>Supported (General tab)</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1177"></A>StaticBind</td>
<td  rowspan="1"  ><A NAME="TI1178"></A>Supported (Transaction tab)</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1179"></A>DisableBind</td>
<td  rowspan="1"  ><A NAME="TI1180"></A>Supported (Transaction tab)</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1181"></A>Init_Prompt</td>
<td  rowspan="1"  ><A NAME="TI1182"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1183"></A>TimeOut</td>
<td  rowspan="1"  ><A NAME="TI1184"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1185"></A>LCID</td>
<td  rowspan="1"  ><A NAME="TI1186"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1187"></A><strong>Transaction tab:</strong></td>
<td  rowspan="1"  ><A NAME="TI1188"></A></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1189"></A>Block</td>
<td  rowspan="1"  ><A NAME="TI1190"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1191"></A>PBMaxBlobSize</td>
<td  rowspan="1"  ><A NAME="TI1192"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1193"></A>Mode</td>
<td  rowspan="1"  ><A NAME="TI1194"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1195"></A>Lock</td>
<td  rowspan="1"  ><A NAME="TI1196"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1197"></A><strong>Syntax tab:</strong></td>
<td  rowspan="1"  ><A NAME="TI1198"></A></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1199"></A>DelimitIdentifier</td>
<td  rowspan="1"  ><A NAME="TI1200"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1201"></A>IdentifierQuoteChar</td>
<td  rowspan="1"  ><A NAME="TI1202"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1203"></A>DateFormat</td>
<td  rowspan="1"  ><A NAME="TI1204"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1205"></A>TimeFormat</td>
<td  rowspan="1"  ><A NAME="TI1206"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1207"></A>DecimalSeparator</td>
<td  rowspan="1"  ><A NAME="TI1208"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1209"></A>OJSyntax</td>
<td  rowspan="1"  ><A NAME="TI1210"></A>Supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1211"></A><strong>Security tab:</strong></td>
<td  rowspan="1"  ><A NAME="TI1212"></A></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1213"></A>EncryptPassword</td>
<td  rowspan="1"  ><A NAME="TI1214"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1215"></A>CacheAuthentication</td>
<td  rowspan="1"  ><A NAME="TI1216"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1217"></A>PersistSensitive</td>
<td  rowspan="1"  ><A NAME="TI1218"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1219"></A>MaskPassword</td>
<td  rowspan="1"  ><A NAME="TI1220"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1221"></A>PersistEncrypted</td>
<td  rowspan="1"  ><A NAME="TI1222"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1223"></A>IntegratedSecurity</td>
<td  rowspan="1"  ><A NAME="TI1224"></A>Supported (TrustedConnection on General
tab)</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1225"></A>ImpersonationLevel</td>
<td  rowspan="1"  ><A NAME="TI1226"></A>Not supported</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1227"></A>ProtectionLevel</td>
<td  rowspan="1"  ><A NAME="TI1228"></A>Not supported</td>
</tr>
</table>
<A NAME="TI1229"></A><h4>Additional database parameters</h4>
<A NAME="TI1230"></A><p>The SNC interface also supports the ReCheckRows and BinTxtBlob runtime-only
parameters, the Encrypt, TrustServerCertificate, and SPCache parameters
(on the System tab page), and the Identity parameter (on the Syntax tab
page).</p>
<A NAME="TI1231"></A><h4>SPCache database parameter</h4>
<A NAME="TI1232"></A><p>You can control how many stored procedures are cached with
parameter information by modifying the setting of the SPCache database
parameter. The default is 100 procedures. To turn off caching of
stored procedures, set SPCache to 0.</p>
<A NAME="TI1233"></A><p>For more information about database parameters supported by
the SNC interface, see the <i>Connection Reference</i> in
the online Help.</p>

